CREATE VIEW [dbo].[vSoaGroupMemberSummaryEvent]
WITH SCHEMABINDING
AS
    SELECT  CAST('EVENT-' + [mm].[MEETING] + ':' + CAST([o].[ORDER_NUMBER] AS VARCHAR(10)) AS VARCHAR(50)) AS GroupMemberId,
            CAST('EVENT-' + [mm].[MEETING] AS VARCHAR(50)) AS [GroupId],
            [o].[ST_ID] AS [PartyId],
            CAST(NULL AS VARCHAR(70)) AS [PartyName],
            CAST(1 AS BIT) AS [IsActive],
            [o].[ORDER_DATE] AS [JoinDate],
            NULL AS [DropDate]
      FROM  [dbo].[Meet_Master] AS [mm]
            INNER JOIN [dbo].[Order_Meet] AS [om] ON [mm].[MEETING] = [om].[MEETING]
            INNER JOIN [dbo].[Orders] AS [o] ON [om].[ORDER_NUMBER] = [o].[ORDER_NUMBER]
     WHERE  [o].[STAGE] != 'CANCELED'
            AND [o].[STATUS] != 'C'

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupMemberSummaryEvent] ON [dbo].[vSoaGroupMemberSummaryEvent] ([GroupMemberId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryEvent_GroupId] ON [dbo].[vSoaGroupMemberSummaryEvent] ([GroupId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryEvent_PartyId] ON [dbo].[vSoaGroupMemberSummaryEvent] ([PartyId]) ON [PRIMARY]
GO